create proc AuthorCount ( @state varchar(2), @count int output ) AS SELECT @count=count(*) FROM authors WHERE state = @state